package com.qianyu.project.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.qianyu.project.entity.DeviceCollect;
import com.qianyu.project.entity.DeviceInspectList;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @Author mfy
 * @desc
 */
@Repository
public interface DeviceInspectListMapper extends BaseMapper<DeviceInspectList> {

    @Select("select * from device_inspect_list dil,device_inspect di,material_info mi where dil.d_inspect_id = di.id and dil.material_id = mi.id and dil.d_inspect_id=#{value}")
    List<DeviceInspectList> selectMaterialInfos(String id);
}
